package com.tanhua.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.tanhua.domain.AnalysisByDay;
import com.tanhua.domain.Log;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

public interface AnalysisByDayMapper extends BaseMapper<AnalysisByDay> {
    @Select("select sum(num_registered) from tb_analysis_by_day")
    Long queryCumulativeUsers();
    @Select("select sum(num_active) from tb_analysis_by_day where record_date<=#{todayStr} and record_date>=#{passDay}")
    Long queryActivePass(@Param("todayStr") String todayStr, @Param("passDay") String passDay);

}
